<#assign fields=parm["fields"] >
<#assign charArr=["A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z","AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ","BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO","BP","BQ","BR","BS","BT","BU","BV","BW","BX","BY","BZ","CA","CB","CC","CD","CE","CF","CG","CH","CI","CJ","CK","CL","CM","CN","CO","CP","CQ","CR","CS","CT","CU","CV","CW","CX","CY","CZ","DA","DB","DC","DD","DE","DF","DG","DH","DI","DJ","DK","DL","DM","DN","DO","DP","DQ","DR","DS","DT","DU","DV","DW","DX","DY","DZ","EA","EB","EC","ED","EE","EF","EG","EH","EI","EJ","EK","EL","EM","EN","EO","EP","EQ","ER","ES","ET","EU","EV","EW","EX","EY","EZ"] >

{
	"cells": [
		{
			"shape": "edge",
			"attrs": {
				"line": {
					"stroke": "#7c68fc",
					"targetMarker": {
						"name": "block",
						"width": 12,
						"height": 8
					}
				}
			},
			"id": "0d66ed01-27a7-45ae-bc6e-8e0ae1819b79",
			"zIndex": 0,
			"source": {
				"cell": "4fd0e397-242d-4b2a-b056-c2dbd8182d88",
				"port": "a2ee070e-892e-4476-9018-c1a69aec367f"
			},
			"target": {
				"cell": "c1565e22-8e36-4f20-9b11-51587d81204d",
				"port": "e5c9ef49-66c5-4289-9926-ccb928d1ce0d"
			}
		},
		{
			"shape": "edge",
			"attrs": {
				"line": {
					"stroke": "#7c68fc",
					"targetMarker": {
						"name": "block",
						"width": 12,
						"height": 8
					}
				}
			},
			"id": "9c25ddb2-5d6e-4b1a-9b9f-dac93860c58f",
			"zIndex": 0,
			"labels": [
				"isDownExcel=='0'"
			],
			"source": {
				"cell": "c1565e22-8e36-4f20-9b11-51587d81204d",
				"port": "b74926e9-f38a-4dbf-9553-3674bb61db1d"
			},
			"target": {
				"cell": "48eaf882-a2d7-4742-bef7-b02d552bd518",
				"port": "db72e204-2893-4b50-9f4a-6ea2a5c2fcdc"
			}
		},
		{
			"shape": "edge",
			"attrs": {
				"line": {
					"stroke": "#7c68fc",
					"targetMarker": {
						"name": "block",
						"width": 12,
						"height": 8
					}
				}
			},
			"id": "de252813-fa3d-4443-a0ee-81e449b87a0e",
			"zIndex": 0,
			"labels": [
				"isDownExcel=='1'"
			],
			"source": {
				"cell": "c1565e22-8e36-4f20-9b11-51587d81204d",
				"port": "f57bd376-835c-4cc5-810f-5b89db77707f"
			},
			"target": {
				"cell": "1cdf3d51-9e89-4ffc-93db-e73833a972ae",
				"port": "ca0b6867-b1ca-4a85-a472-0ae75b155742"
			}
		},
		{
			"shape": "edge",
			"attrs": {
				"line": {
					"stroke": "#7c68fc",
					"targetMarker": {
						"name": "block",
						"width": 12,
						"height": 8
					}
				}
			},
			"id": "2e2e12ff-a53a-442e-b65d-6c9b656cccd2",
			"zIndex": 0,
			"source": {
				"cell": "1cdf3d51-9e89-4ffc-93db-e73833a972ae",
				"port": "fa52cd01-9a99-48ab-a547-9c612ddd9db8"
			},
			"target": {
				"cell": "48eaf882-a2d7-4742-bef7-b02d552bd518",
				"port": "db72e204-2893-4b50-9f4a-6ea2a5c2fcdc"
			}
		},
		{
			"position": {
				"x": 410,
				"y": 510
			},
			"size": {
				"width": 100,
				"height": 38
			},
			"attrs": {
				"body": {
					"fill": "#67C23A",
					"stroke": "orange",
					"strokeWidth": "2",
					"ValTxt": "结束组件",
					"ValType": "end"
				},
				"label": {
					"fill": "#fff",
					"refX": "50%",
					"textAnchor": "middle",
					"text": "结束组件",
					"y": 20
				},
				"variable": {
					"text": null
				},
				"field": {
					"text": null
				},
				"position": {
					"0": "b",
					"1": "o",
					"2": "t",
					"3": "t",
					"4": "o",
					"5": "m"
				}
			},
			"shape": "custom-node",
			"tools": {
				"items": [
					{
						"name": "button-remove",
						"args": {
							"x": 100,
							"y": 0
						}
					}
				]
			},
			"id": "48eaf882-a2d7-4742-bef7-b02d552bd518",
			"zIndex": 2,
			"formData": {
				"type": "end",
				"code": 1693116188333,
				"name": "处理结束",
				"flag": "200",
				"msg": "",
				"argProperties": [
					{
						"sourceDataName": "refInfo",
						"type": true
					}
				],
				"circulationList": []
			},
			"ports": {
				"groups": {
					"top": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"right": {
						"position": "right",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"bottom": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"left": {
						"position": "left",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"end": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#31d0c6",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"start": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					}
				},
				"items": [
					{
						"group": "end",
						"id": "db72e204-2893-4b50-9f4a-6ea2a5c2fcdc"
					}
				]
			}
		},
		{
			"position": {
				"x": 410,
				"y": 130
			},
			"size": {
				"width": 100,
				"height": 38
			},
			"attrs": {
				"body": {
					"fill": "#67C23A",
					"stroke": "#2dc9be",
					"strokeWidth": "1",
					"ValTxt": "开始组件",
					"ValType": "start"
				},
				"label": {
					"fill": "#fff",
					"refX": "50%",
					"textAnchor": "middle",
					"text": "开始组件",
					"y": 20
				},
				"variable": {
					"text": null
				},
				"field": {
					"text": null
				},
				"position": {
					"0": "b",
					"1": "o",
					"2": "t",
					"3": "t",
					"4": "o",
					"5": "m"
				}
			},
			"shape": "custom-node",
			"tools": {
				"items": [
					{
						"name": "button-remove",
						"args": {
							"x": 100,
							"y": 2,
							"zIndex": 10
						}
					}
				]
			},
			"id": "4fd0e397-242d-4b2a-b056-c2dbd8182d88",
			"zIndex": 5,
			"formData": {
				"type": "start",
				"code": 1693116187718,
				"name": "开始节点",
				"circulationList": [
					{
						"linkID": "0d66ed01-27a7-45ae-bc6e-8e0ae1819b79",
						"condition": "",
						"nodeId": "c1565e22-8e36-4f20-9b11-51587d81204d",
						"nodeName": "名称：查询数据的返回信息"
					}
				]
			},
			"ports": {
				"groups": {
					"top": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"right": {
						"position": "right",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"bottom": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"left": {
						"position": "left",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"end": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#31d0c6",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"start": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					}
				},
				"items": [
					{
						"group": "start",
						"id": "a2ee070e-892e-4476-9018-c1a69aec367f"
					}
				]
			}
		},
		{
			"position": {
				"x": 310,
				"y": 280
			},
			"size": {
				"width": 300,
				"height": 80
			},
			"attrs": {
				"body": {
					"fill": "#fff",
					"stroke": "#2dc9be",
					"strokeWidth": "1",
					"ValTxt": "快速查列表",
					"ValType": "DB_FAST_QUERY_LIST"
				},
				"label": {
					"text": "快速查列表",
					"y": 15
				},
				"variable": {
					"fill": "#004EA2",
					"text": "名称：查询数据的返回信息",
					"title": "查询数据的返回信息"
				},
				"field": {
					"fill": "green",
					"text": "出参：refInfo"
				},
				"position": {
					"0": "b",
					"1": "o",
					"2": "t",
					"3": "t",
					"4": "o",
					"5": "m"
				}
			},
			"shape": "custom-node",
			"tools": {
				"items": [
					{
						"name": "button-remove",
						"args": {
							"x": 300,
							"y": 0
						}
					}
				]
			},
			"id": "c1565e22-8e36-4f20-9b11-51587d81204d",
			"formData": {
				"type": "DB_FAST_QUERY_LIST",
				"code": 1693619644163,
				"name": "查询数据的返回信息",
				"variableName": "refInfo",
				"table": "${parm.tableName}",
				"ALL": null,
				"COLUMNS": "<#list fields as item > ${item.columnName} <#if item?index < (fields?size - 1)>,</#if></#list>",
				"WHERE": {
					<#list fields as item >
					"${item?index}": {
						"left": null,
						"condition1": "${item.columnName}",
						"compute": "like",
						"condition2": "%${r"${"}${item.columnName}${r"}"}%",
						"right": null,
						"logic": "AND"
					}<#if item?index < (fields?size - 1)>,</#if>
					</#list>
				},
				"pagination": "1",
				"PAGE": "${r"${current}"}",
				"SIZE": "${r"${size}"}",
				"ORDER_BY": null,
				"circulationList": [
					{
						"linkID": "9c25ddb2-5d6e-4b1a-9b9f-dac93860c58f",
						"condition": "isDownExcel=='0'",
						"nodeId": "48eaf882-a2d7-4742-bef7-b02d552bd518",
						"nodeName": "结束组件"
					},
					{
						"linkID": "de252813-fa3d-4443-a0ee-81e449b87a0e",
						"condition": "isDownExcel=='1'",
						"nodeId": "1cdf3d51-9e89-4ffc-93db-e73833a972ae",
						"nodeName": "名称：下载Excel文件"
					}
				]
			},
			"zIndex": 8,
			"ports": {
				"groups": {
					"top": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"right": {
						"position": "right",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"bottom": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"left": {
						"position": "left",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"end": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#31d0c6",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"start": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					}
				},
				"items": [
					{
						"group": "top",
						"id": "e5c9ef49-66c5-4289-9926-ccb928d1ce0d"
					},
					{
						"group": "right",
						"id": "f57bd376-835c-4cc5-810f-5b89db77707f"
					},
					{
						"group": "bottom",
						"id": "b74926e9-f38a-4dbf-9553-3674bb61db1d"
					},
					{
						"group": "left",
						"id": "421215a1-a676-435b-a98a-637b16e1f2db"
					}
				]
			}
		},
		{
			"position": {
				"x": 810,
				"y": 280
			},
			"size": {
				"width": 300,
				"height": 80
			},
			"attrs": {
				"body": {
					"fill": "#fff",
					"stroke": "#2dc9be",
					"strokeWidth": "1",
					"ValTxt": "下载Excel",
					"ValType": "FILE_DOWNLOAD_EXCEL"
				},
				"label": {
					"text": "下载Excel",
					"y": 15
				},
				"variable": {
					"fill": "#004EA2",
					"text": "名称：下载Excel文件",
					"title": "下载Excel文件"
				},
				"field": {
					"fill": "green",
					"text": "出参："
				},
				"position": {
					"0": "b",
					"1": "o",
					"2": "t",
					"3": "t",
					"4": "o",
					"5": "m"
				}
			},
			"shape": "custom-node",
			"tools": {
				"items": [
					{
						"name": "button-remove",
						"args": {
							"x": 300,
							"y": 0
						}
					}
				]
			},
			"id": "1cdf3d51-9e89-4ffc-93db-e73833a972ae",
			"formData": {
				"type": "FILE_DOWNLOAD_EXCEL",
				"code": 1694092318067,
				"name": "下载Excel文件",
				"variableName": null,
				"FILE_NAME": "${parm.name}",
				"TEMPLATE_FILE_PATH": "",
				"SHEET_NAME": "sheet1",
				"LIST_NAME": "refInfo.list",
				"START_ROW": "0",
				"MAPPING": {
					<#list fields as item >
					"${item?index}": {
						"IDX": "${charArr[item?index]}",
						"COL_NAME": "${item.name}",
						"NAME": "${item.columnName}",
						"WIDTH": "10"
					}
					<#if item?index < (fields?size - 1)>,</#if>
					</#list>
				},
				"circulationList": [
					{
						"linkID": "2e2e12ff-a53a-442e-b65d-6c9b656cccd2",
						"condition": "",
						"nodeId": "48eaf882-a2d7-4742-bef7-b02d552bd518",
						"nodeName": "结束组件"
					}
				]
			},
			"zIndex": 9,
			"ports": {
				"groups": {
					"top": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"right": {
						"position": "right",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"bottom": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"left": {
						"position": "left",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"end": {
						"position": "top",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#31d0c6",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					},
					"start": {
						"position": "bottom",
						"attrs": {
							"circle": {
								"r": 8,
								"magnet": true,
								"stroke": "#873bf4",
								"strokeWidth": 1,
								"fill": "#fff",
								"style": {
									"visibility": "hidden"
								}
							}
						}
					}
				},
				"items": [
					{
						"group": "top",
						"id": "ac7a05db-4529-4673-b6e5-14e84e1b4f86"
					},
					{
						"group": "right",
						"id": "45d5015c-f0ff-47f3-9f2a-9b2bb6fa957b"
					},
					{
						"group": "bottom",
						"id": "fa52cd01-9a99-48ab-a547-9c612ddd9db8"
					},
					{
						"group": "left",
						"id": "ca0b6867-b1ca-4a85-a472-0ae75b155742"
					}
				]
			}
		}
	],
	"rectId": 1
}